[SQL server] How to insert artificial data into a select statement
Posted
by user149578
on Stack Overflow
See other posts from Stack Overflow
or by user149578
Published on 2010-03-12T08:47:34Z
Indexed on
2010/03/12
8:57 UTC
Read the original article
Hit count: 188
Filed under:
sql-server
Hi guys:
Suppose we got a original query as follows:
SELECT A, B, C FROM tblA
Now, I need to additional artificial rows like SELECT 'Kyala', B, C FROM tblA when, for example, C = 100 to be inserted into the resultset.
How could I achieve it using a single SQL instead of relying on table variable or temp table?
© Stack Overflow or respective owner
